2013-09-12 - 7358.400 - Rel Notes - Report on ROAL Data #BIReleases2013

Release Notes:

7358.400 - Report on ROAL Data


Admin Info

Purpose
 To write the report on ROAL material with its images and details.
Release No
 001
Submitted
 09-13-2013
Submitted by
 Mallareddy D
Source/Destination Systems
 Remote Machine to IT -> BMS -> Production
Release Sent To
 Ashwin Kucheriya
Object(s) Created By
 Mallareddy D
Object(s) Tested By
 Mallareddy D

Report Name

OSA190 - Open Orders by ROAL Material.

BEx Query

ZMP_OOCON_Q015

NEC Crystal Reports Standards Check

1. OSA190 has been successfully checked against the NEC Crystal Reports Standards Checklist.
2. OSA190 CR checklist has been sent to NEC and also attached here for reference:
OSA190 NEC CR Standard Check List.xlsx

Dynamic Group 1:

Test Conducted

Group: Region > Sales Org > BU > Silhouette > Year > Material

Summary Level Check

Test Conducted

Group: North America
S.no
 Test case Name
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 1,114,516
 1,114,516
 Pass
2
 Revenue
 13,643,488
 13,643,488.17
 Pass

Group: EMEA Sales
S.no
 Test case Name
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 8,660
 8,660
 Pass
2
 Revenue
 122,661
 122,661.99
 Pass

Secondary Level Check

Test Conducted

Group: Emerging Markets > Australia Sales
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 12,725
 12,725
 Pass
2
 Revenue
 214,496
 214,495.86
 Pass

Group: North America > Canada Sales
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 139,024
 139,024
 Pass
2
 Revenue
 1,675,568
 1,675,567.33
 Pass

Third Level Check

Test Conducted

Group: EMEA Sales > EMEA Sales > NEW ERE BRANDED
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 1,427
 1,427
 Pass
2
 Revenue
 21,747
 21,747.18
 Pass

Group: Emerging Markets > Mexico Sales > FANGEAR
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 124
 124
 Pass
2
 Revenue
 1,725
 1,724.54
 Pass

Fourth Level Check

Test Conducted

Group: North America > United States Sales > KIDS > KID5950
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 30,263
 30,263
 Pass
2
 Revenue
 293,369
 293,369.02
 Pass

Group: EMEA > EMEA Sales > ENTERTAINMENT > 5950
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 670
 670
 Pass
2
 Revenue
 7,462
 7,461.82
 Pass

Fifth Level Check

Test Conducted

Group: Emerging Markets > APAC Sales > LIFE STYLE > 950 > 2013
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 8,929
 8,929
 Pass
2
 Revenue
 112,327
 1,12,326.62
 Pass

Group: North America > Canada Sales > COLLEGE > 5950 OB > 2013
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 90
 90
 Pass
2
 Revenue
 1,179
 1,178.84
 Pass

Sixth Level Check

Test Conducted

Group: EMEA > EMEA Sales > BASEBALL - ON FIELD > 5950 > 2013 > 70106983 - ACPERF MIAMAR HM
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 210
 210
 Pass
2
 Revenue
 2,938
 2,938.15
 Pass

Group: Emerging Markets > NEC Korea Sales > BASEBALL - ON FIELD > 5950 > 2013 > 70035114 - ACPERF SAFGIA ALT
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 574
 574
 Pass
2
 Revenue
 8,067
 8,067.16
 Pass

Dynamic Group 2:

Test Conducted

Group: Region > Sales Org > BU > License> Team > Year > Material

Summary Level Check

Test Conducted

Group: Emerging Markets
S.no
 Test case Name
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 82,621
 82,621
 Pass
2
 Revenue
 1,218,460
 1,218,460.24
 Pass

Group: EMEA Sales
S.no
 Test case Name
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 8,660
 8,660
 Pass
2
 Revenue
 122,661
 122,661.99
 Pass

Secondary Level Check

Test Conducted

Group: North America > United States Sales
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 975,462
 975,492
 Pass
2
 Revenue
 11,967,921
 11,967,920.84
 Pass

Group: Emerging Markets > Latin America Sales
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 13,691
 13,691
 Pass
2
 Revenue
 155,959
 155,958.75
 Pass

Third Level Check

Test Conducted

Group: EMEA > EMEA Sales > LIFE STYLE
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 5,547
 5,547
 Pass
2
 Revenue
 82,889
 82,889.27
 Pass

Group: North America > Canada Sales > TEAM EQUIPMENT
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 282
 282
 Pass
2
 Revenue
 3,822
 3,822.31
 Pass

Fourth Level Check

Test Conducted

Group: Emerging Markets > Mexico Sales > FANGEAR > MLB PROPERTIES
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 122
 122
 Pass
2
 Revenue
 1,716
 1,716
 Pass

Group: EMEA > EMEA Sales > NEW ERA BRANDED > NON LICENSED
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 1,338
 1,338
 Pass
2
 Revenue
 17,824
 17,823.70
 Pass

Fifth Level Check

Test Conducted

Group: North America > United State Sales > HOT MARKET > MINOR LEAGUE > SALT LAKE CITY BEE
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 36
 36
 Pass
2
 Revenue
 306
 306.00
 Pass

Group: Emerging Markets > Australia Sales > KIDS > AUSTRALIAN FOOTBALL > CARLTON BLUES
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 6
 6
 Pass
2
 Revenue
 78
 77.95
 Pass

Sixth Level Check

Test Conducted

Group: EMEA > EMEA Sales > ENTERTAINMENT > DISNEY > MICKEY MOUSE > 2013
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 73
 73
 Pass
2
 Revenue
 1,338
 1,337.86
 Pass

Group: North America > Canada Sales > HOT MARKET > WESTERN HOCKEY LEAGUE > VANCOUVER GIANTS > 2013
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 45
 45
 Pass
2
 Revenue
 428
 427.81
 Pass

Seventh Level Check

Test Conducted

Group: Emerging Markets > APAC Sales > BASEBALL - ON FIELD > MLB PROPERTIES > SAN FRANCISCO GIANTS > 2013 > 70035114 - ACPERF SAFGIA ALT
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 4
 4
 Pass
2
 Revenue
 53
 52.80
 Pass

Group: EMEA > EMEA Sales > FANGEAR > NFL PROPERTIES > ATLANTA FALCONS > 2013 > 70187021 - 3930 ATLFAL BLK TM
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 36
 36
 Pass
2
 Revenue
 121
 120.74
 Pass

Reference Document(Specification)

2013-09-06 - 7358.400 - Spec - Report on ROAL Data